SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415115 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415115 [ RunTime:0.004016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197205,286597,681937,772981,665736,689622,886336,260348,207777,106623,659333,33306,567097,810880,304766,186324,225278,179020,200863,259144,664584,501220,64544,639055,337962,50982,711753,753308,461666,242990,424770,295489,47046,386785,610106,127606,963752,366522,391029,751853,427011,712779,553313,316692,88598,171799,426366,53117,376432,1043106,150706,357679,1009299,753343,461189,588404,472609,785564,186593,105197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]