SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562208 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562208 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14857,587837,74352,853503,57539,943164,480809,378409,356403,216123,569132,519492,67200,784656,898879,545041,120804,734174,502911,661090,823532,487460,100974,596774,1007095,191075,93871,400438,268650,685932,825612,571423,365845,314242,701479,627372,22619,604948,593702,835146,947723,248711,453333,745092,574567,134137,302376,356537,675074,96269,513410,929001,160716,1025737,96982,926311,353249,180202,651621,778911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]