SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103090 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103090 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482736,325788,467251,623007,1028029,526421,747317,844689,884048,931680,952003,261318,1975,82161,506950,800915,996873,541460,103469,820708,719838,164538,338035,465440,691853,1012716,255507,563528,269570,961010,845285,247163,700158,72008,490612,527666,101559,140849,992911,537397,863965,532917,1045213,702643,762347,625172,849188,603550,270487,120310,987780,5230,147045,572129,631277,526804,87985,806695,130990,966250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000876s ]