SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013200 LIMIT 1 [ RunTime:0.001836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013200 [ RunTime:0.005162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286701,124051,986680,473803,594866,367402,203952,748856,867485,127667,767194,676431,343008,89195,657412,236746,572941,905686,357179,291522,384816,1019216,330092,277190,205837,796098,575852,14120,578200,49095,772721,480265,422425,266700,367244,471175,1008298,377336,577671,637488,889042,513261,301999,816671,136142,475690,712380,408967,208374,633151,93810,454204,106186,294169,658177,623548,182507,241013,375446,721530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002374s ]