SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40422 LIMIT 1 [ RunTime:0.001350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40422 [ RunTime:0.003723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994034,960133,252867,849575,290831,3965,450517,348513,257080,52134,832821,466966,722218,555872,147505,82291,446461,57458,600888,305761,328948,110860,216069,156990,521530,393460,25157,418068,487796,967406,653930,543887,282259,3810,33032,524273,456039,736294,930821,260861,1000013,296959,318777,970181,546878,859720,33198,451532,667673,130992,855082,809873,559338,318044,1001494,203594,1034381,663482,669884,489989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]