SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540010 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540010 [ RunTime:0.004700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402322,671208,816458,154913,123411,371339,142117,886407,992388,368974,59337,1014342,193201,464912,512153,111297,285378,336998,839915,623769,1015457,990989,799723,135088,879907,849783,759722,842853,954685,931109,470914,66177,537479,1007443,392825,424209,46449,86361,243750,790266,38489,416625,41253,484122,926240,648101,559433,980114,890537,422705,179832,477802,642453,18131,885701,639833,714357,387399,42065,557591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]