SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502278 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502278 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778582,589939,239745,761493,583441,421340,701711,371484,1032726,236512,6712,775395,72823,865269,816503,715363,760435,698567,125103,849040,878989,684151,1037310,887233,792718,753221,162866,719369,781819,487390,903351,1045876,1046992,960335,203704,460717,643371,134765,361826,936617,504933,636514,704467,641449,886082,368835,419591,820630,980461,861571,864584,195519,268596,771495,379744,897936,538734,361063,355732,221117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502278 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502278 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]