SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286200 LIMIT 1 [ RunTime:0.000801s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286200 [ RunTime:0.002188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422580,684555,273283,368332,675144,196244,223463,1039511,408682,181836,989894,255161,192248,81086,727683,809312,708402,273430,582926,522500,250947,45590,634367,385456,176837,632092,834711,1007551,69082,424628,467123,721384,840197,288104,447920,360446,160562,1018810,988518,80797,566739,487342,104101,725525,187398,678255,491586,115325,761299,477857,439551,359872,794790,50260,339819,64562,210695,953175,106581,672877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]