SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199817 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199817 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645131,110721,623330,666554,840725,1035058,841936,731981,795968,1033287,730287,427780,524439,1030562,788429,476934,583123,512880,914523,629896,1037838,771009,451465,428670,874520,972089,388041,545441,850144,693130,1033924,981757,90006,801546,468874,317372,534209,862187,924666,584290,764460,168250,898577,159395,170902,789407,219578,115880,325880,85514,503855,859959,262072,939229,160636,765378,148271,295707,522830,573100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]