SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580820 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580820 [ RunTime:0.003058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753980,387295,585487,532597,341753,772378,316849,457602,869431,401670,787475,737815,496446,233737,762051,20153,320766,189753,634936,655185,320268,888516,423888,371144,761195,271411,311226,48650,555894,559519,401266,815290,818702,297074,557650,227388,443395,736267,217490,1048297,304737,651989,934796,888496,124382,302736,280740,526289,121775,1015652,559654,229850,477173,963169,72870,339952,677278,891533,954370,963388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002036s ]