SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035697 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035697 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270073,150590,71355,37254,323873,1033280,379780,512970,20105,971844,471396,256313,996399,703667,169347,552392,273132,561997,20963,793510,446245,977194,429658,245313,357753,124626,257921,1026027,1027151,859279,997874,488852,331558,19865,56568,471303,1041183,710194,657563,154430,270070,590287,740677,81164,423800,809166,118534,721781,496673,221900,82726,1034424,16069,1025398,915575,412749,226150,672994,468002,211226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]