SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483083 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483083 [ RunTime:0.002972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312859,754069,796683,74432,644570,810343,856885,28803,932426,895392,590329,290768,362582,276449,197296,28364,956673,732652,702263,962078,369448,257962,198514,881904,504023,78082,922653,939929,747477,665012,879815,948438,98393,537331,860740,45621,498660,702393,410286,383905,6122,454884,894945,96519,608614,91277,108386,677649,302782,557173,815132,657294,1004802,731470,384988,222228,816968,380815,222054,893940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]