SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039102 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039102 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027636,483633,704269,910814,441769,565441,33703,483541,486322,688076,95440,318654,468087,444923,694853,678072,453610,30485,1004425,828528,145141,637948,6573,1003663,56599,336847,924441,470854,686669,815963,20267,399679,820276,402475,920179,40446,16679,13007,532983,829303,438714,285723,963439,845806,154688,768291,144408,111353,136139,945917,1018862,946509,556441,553823,466961,701677,194372,138392,574460,775023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]