SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591423 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591423 [ RunTime:0.003721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020396,73996,936298,342638,412183,420080,81347,79758,110894,905913,558938,840513,640511,100057,396692,469502,621752,369185,799206,591509,652871,745022,1015328,506079,437544,588652,799984,670077,369011,488852,277276,1018881,954983,679995,424215,681480,650508,986934,544532,605240,359500,798919,43360,213994,930641,107280,1007098,933738,997183,661274,175449,998454,40396,789904,69705,1027113,460885,154679,814063,620604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]