SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682019 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682019 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369939,551296,711346,311645,1007729,752852,290415,715506,12700,384064,274948,865448,183481,813233,622347,675622,800978,604814,160201,907056,492176,644856,817798,289386,710750,970232,432918,983533,609768,7257,101889,684715,146140,1040312,702789,128049,384548,740632,758648,579681,582700,45508,1041097,558078,997968,592018,891999,106110,735642,169959,1022577,963619,757136,407474,725034,204903,420173,306271,864924,940751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]