SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20170 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20170 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268404,425895,948892,462693,615253,683606,751699,971653,917535,995010,390296,1035296,680885,748762,458915,769184,453089,276281,332223,793835,898577,177825,543346,816111,531499,788938,58462,434051,436185,292813,301654,941220,227534,604198,905637,655049,372575,811573,471403,146075,1002555,771908,272714,166166,885824,374959,523512,866714,861921,57601,370305,193483,625278,958670,880616,801645,789295,490843,596983,988521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]