SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030092 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030092 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266740,37938,669360,226859,803283,1038728,928754,632561,574255,936902,719084,889321,963861,547039,339588,286813,1044847,204222,1040538,889520,896956,245369,834880,792917,133377,269070,752329,22606,656906,664645,35663,26801,706196,856707,930695,148106,620735,624299,323468,732941,676003,264598,765157,264699,1001430,379858,999060,649273,934029,666597,399931,784729,442530,298434,183663,83363,346,741079,705962,626501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]