SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318300 LIMIT 1 [ RunTime:0.004586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318300 [ RunTime:0.004694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238112,902518,548068,837582,195984,127296,531531,999293,270285,567086,329922,147057,648167,322249,229028,53801,225126,559193,520411,217976,442647,670159,619797,789664,50320,390578,561578,547315,1042528,160684,500349,159200,177790,594193,223532,126516,373297,472568,230136,317119,189074,864260,282663,801844,446588,1041925,642093,101264,556878,605910,205891,331014,81201,718204,43740,855982,943467,600505,982474,196368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]