SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419684 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419684 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442516,634050,764509,200792,614011,512898,595520,512716,631650,933920,336826,424585,656727,228907,984865,338339,889688,65436,374964,578368,394900,899112,495625,756961,518299,978489,204761,143565,85476,541522,809596,68147,722704,93829,96097,631857,435832,938218,796519,792891,422968,827281,627891,915925,419135,735227,829260,636364,675743,151867,91550,88085,985994,555885,644338,948838,1023023,679609,661497,69640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]