SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 355078 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 355078 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675013,319819,545101,641927,716182,748747,672610,381490,257568,39251,59215,172722,803615,1023158,682287,31964,137000,473667,192965,896881,884891,934888,627410,476205,796847,426351,918526,1029563,208031,680139,9921,982747,687988,910383,557291,513528,639440,381689,438496,1003972,105575,563485,456881,404877,341834,344949,504209,762874,998328,994275,1028184,1041386,453275,523225,541840,54072,672000,21271,270390,38787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 355078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 355078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]