SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416978 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416978 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301210,872279,902130,824148,244190,666941,722683,499843,537150,371816,371074,1009465,922435,271433,1004282,998749,1033213,559190,472433,363211,14841,713476,847462,459752,105280,699810,475653,959418,322514,768186,57887,587883,480379,48722,263091,320152,983077,710448,33782,99963,514437,43857,298279,991650,284299,81452,264391,26462,142819,222422,993084,140668,1024907,492450,192965,861649,565602,1040794,416902,484288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]