SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10147 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10147 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174404,331602,1016069,564913,178097,859615,76120,16048,889568,673129,668826,641923,235115,627201,274788,482724,674249,973751,1023674,515299,111557,854999,948859,428700,962912,407393,284686,256758,782733,472751,684437,557548,26817,954718,877088,947222,29327,776645,891906,785601,422297,856952,530320,413796,365543,54401,560814,214589,228816,646166,470034,34903,177848,129519,403640,415278,941903,554807,441599,804409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]