SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502092 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502092 [ RunTime:0.000940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15237,124348,1021534,523469,1030685,846210,987206,814029,854364,226822,144895,100257,35940,972075,997484,402143,97067,908852,480324,215490,894954,16057,892599,982348,188424,525247,708428,898971,236113,860971,216291,737428,452363,675046,967154,719685,418345,553918,219810,42806,952725,555738,175853,78746,898516,937203,573944,59313,953827,823347,996255,812898,676119,644714,10144,369901,377108,208376,321790,985106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]