SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261212 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261212 [ RunTime:0.003406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303241,738029,511158,70264,202809,748607,610888,251956,189359,562637,1048889,174931,819471,999865,496500,992088,351480,996461,390731,431052,144837,113093,401993,101657,493312,621866,45758,799713,1014984,78069,465733,679022,530109,72387,243612,58521,202322,434684,285205,656893,811245,1047536,748672,896303,843115,981711,43399,825141,12527,630031,475382,381227,143027,882389,262360,978384,442589,451567,790525,941162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000805s ]