SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405391 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405391 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973818,787539,534868,985195,404943,1001823,383737,113812,412793,692523,190845,967777,164533,239104,708822,284197,261766,363037,50651,672197,1019389,906129,865943,421064,334762,439039,460479,997606,237695,353874,470187,872423,530909,469506,445076,147721,454122,724911,164748,943707,922644,820813,171595,475214,326924,276335,715375,727095,808205,46527,325218,783289,574566,904986,522873,515318,453664,315730,153229,70918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]