SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467482 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467482 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464882,53286,73644,168793,643798,413877,399047,1023789,325062,453690,617209,638291,516337,931773,1036413,949141,670069,678835,237168,677781,244345,726108,656468,824796,928399,580961,895780,550265,938988,201854,352347,262455,184375,702769,689471,147469,670861,779197,473554,914296,24644,290296,216721,243884,356146,445378,906330,991317,3532,467586,351968,490885,732155,815255,741933,80377,601196,386088,883916,667049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]