SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022564 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022564 [ RunTime:0.003238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642256,526895,101221,963023,380265,422094,516505,850470,937655,819283,292750,140850,205979,499079,997663,901883,868592,272680,598480,744999,240437,418367,827040,77380,386813,268774,732314,230045,761980,688908,64708,759811,438651,522004,597944,311947,662704,193415,848142,237185,1030250,428367,192908,1016701,625691,76266,473682,535859,265667,936321,13912,877463,15743,708686,90854,660651,882972,560424,331818,100076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000868s ]