SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400011 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400011 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828577,110662,236515,833761,566935,886584,141154,188216,279963,475723,955059,909216,1034676,958813,1000963,293090,144699,645773,144825,884354,43315,982059,621297,423576,1020676,176204,808180,597121,838496,317480,290061,616235,664722,373758,515554,737663,844778,437558,420440,626070,18347,821453,205070,209790,860542,349932,675197,746136,23876,79430,604301,748603,129910,584363,62155,283772,731768,140136,753115,922602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000941s ]