SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14810 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14810 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443833,92844,568269,978854,572694,864368,573108,508930,21380,653181,893623,1022335,87847,470661,97231,84935,485043,629008,810447,70819,504298,22866,695005,124345,727902,333837,693013,138821,184833,630098,244756,196035,692000,442919,120316,160815,11022,847783,457088,132273,355599,966215,167718,178210,305038,719190,847983,566165,521000,427395,795306,599972,835955,125141,878971,727526,935919,1018878,404993,70654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001205s ]