SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841583 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841583 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518676,472651,868714,824222,461558,778373,248367,368931,566035,955353,954300,24890,724110,1052,82020,516999,504189,15670,931915,858264,164616,171968,996031,383018,72638,722335,684828,814267,124310,396567,263256,365621,483205,492778,538784,447560,616081,250768,1006099,735978,418375,833676,204,726299,367179,983552,126544,555584,685673,128633,301765,420859,1020068,169462,991889,817766,106155,195830,1030059,413782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]