SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539023 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539023 [ RunTime:0.002291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639392,230901,459177,472460,385878,916454,715470,609559,469587,200145,365564,616454,19710,590863,308446,436600,771169,900009,645465,87799,2012,299905,904648,533490,843840,388126,134320,160132,171388,839342,745512,216589,408144,166391,747564,700418,643874,743367,338627,52172,403259,492929,663053,17297,732172,308771,718754,331094,58925,167179,289688,186705,580258,749056,477595,799246,728394,440764,523901,125049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]