SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005676s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023068 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023068 [ RunTime:0.006438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534485,178218,1004383,649217,836193,405339,907688,317885,554885,1024929,494008,167077,752099,631045,155576,990015,708262,810758,1022612,908534,102850,1002531,27964,945546,997063,855856,323669,37296,679545,1024330,514001,965324,505926,292141,539589,828424,843206,80512,523162,93444,435396,268823,883499,737317,505535,980963,623706,220048,23190,263763,159267,547441,677247,336275,304383,1018280,67412,659089,291170,77713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]