SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513650 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513650 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422859,19739,96583,514970,804004,597707,726220,65803,650740,148053,194490,385205,61010,557565,801703,219865,186223,772191,916618,434474,606407,730612,567185,235794,20876,442744,156260,89968,29285,350008,463900,1019908,371027,998585,481029,483875,348356,972391,522698,126301,621704,678274,623947,760925,706864,977925,340647,366766,435132,385380,226442,688369,500161,938820,408830,453136,476642,932970,95328,247444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]