SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112068 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112068 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630814,475467,201580,450315,436782,698014,720471,1009896,1014746,62706,443334,45676,359478,634676,755423,352868,93266,378382,876881,803931,775078,641614,254495,195654,240449,188887,797316,88718,68013,976891,492519,25070,328505,171187,516108,924031,23727,502894,877584,212292,276876,119389,687564,47261,765961,338957,425312,53939,993634,963145,859530,671786,500985,380548,817363,33235,65773,782548,938949,549821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]