SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171072 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171072 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197056,842408,801921,422050,493731,316528,265562,747912,992876,593954,658022,1019279,698596,97687,240629,782032,1009495,900427,553546,331815,647590,351536,196980,809544,918603,147056,216300,101429,44111,618372,562618,347173,944684,840693,56202,594233,943889,128499,12521,82942,994313,816633,130217,265595,5755,377177,158016,757496,131752,1038869,473285,504329,848838,583085,801469,535918,404939,703356,390413,236205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003320s ]