SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201405 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201405 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622632,983142,674917,447761,596804,851513,431391,388455,311330,265504,810204,725339,950835,71721,356411,435568,746897,721658,837702,60737,735925,561005,552579,571817,1003845,1045547,477076,526201,766264,903649,127820,418508,882437,990275,494221,975271,128678,588018,964818,605088,488211,299449,618135,367403,431306,509138,255944,571311,351950,867971,15692,461049,618770,250327,145833,944731,857968,97309,357038,421607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003400s ]