SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338085 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338085 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216822,759622,208176,200818,472743,779169,153762,838399,1016140,645993,598886,860309,998797,914525,109595,218253,964941,4873,408666,308403,53058,1019369,294969,307632,974528,965741,212265,220859,10439,636077,125142,592007,840150,524867,694640,215497,930233,982038,97820,352552,199912,142239,419115,302224,367816,798235,119020,167742,457874,239071,221570,267125,329986,318198,24894,983195,758762,629882,790638,1048680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]