SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494108 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494108 [ RunTime:0.002769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599435,158381,810228,342,139620,215300,896986,758125,371443,674199,148210,308236,544947,815829,172556,109860,549439,152860,879627,804098,702779,441378,1024881,454989,520823,146207,379427,539395,398212,968387,280752,331908,269034,210489,84257,708270,759496,320017,602612,16279,738336,770269,569897,648054,27254,14673,771542,995434,739070,268501,158312,854390,520359,510148,487795,990783,858597,73670,285816,87047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]