SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 371411 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 371411 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693920,1042328,470348,478266,902379,367374,737215,813103,622057,747606,552046,757068,1002442,559244,932902,618361,307289,435367,165688,556623,906467,323790,291049,782017,185693,885147,438021,861159,864071,1035765,728348,85596,585240,77930,412239,802633,979545,41860,423391,443657,335448,591205,252176,525219,300157,109008,296947,410122,232647,877215,799670,576543,912453,449987,227079,756823,204202,473873,271582,941654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 371411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 371411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]