SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001972s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019588 LIMIT 1 [ RunTime:0.001861s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019588 [ RunTime:0.005375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379694,295811,868418,218136,594632,405318,1019400,419602,936499,468549,386048,630409,937232,434480,233482,43198,976267,821824,783881,482615,816511,990390,10250,107978,470703,1045471,27313,1025995,212541,232834,873271,5003,21524,996722,631777,343254,382319,148371,441595,206774,747125,485364,772133,749698,796548,933526,871680,946012,571188,646294,609018,951918,186711,258881,424861,834472,568354,392444,181653,265894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001645s ]