SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022539 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022539 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111902,641816,560465,976120,828568,287443,281732,72043,965056,66891,30408,1015578,763574,172456,936994,306970,986711,327632,516096,770961,64811,106573,381885,566679,660476,212116,1017817,789436,281860,464960,1039851,718651,350053,863034,610075,864611,1005623,423050,257194,878172,278270,1041774,17980,678166,273772,560359,408427,457139,569536,858827,161369,910945,521829,188694,940418,967357,611159,493280,955540,962677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]