SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442011 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442011 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658172,456914,1048111,76386,864661,179370,839688,668071,57167,373213,202433,1028398,329374,146460,804009,1038926,591985,155078,39088,801239,670275,140584,448494,792547,820459,495432,742858,304517,95971,204727,571727,949916,464014,47233,313370,483175,222489,136886,756684,950066,439132,423165,174825,282104,755635,610267,97484,186670,172341,99990,584590,830785,794237,276024,194008,981375,253524,968290,948962,110241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]