SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035575 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035575 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698840,456758,803868,496901,397589,126206,941577,183278,778769,686214,1001529,60013,340112,930202,628235,651850,322455,526407,718265,747503,599562,682571,407997,885337,654218,979929,589397,234184,628609,554268,179971,431424,528649,727985,585035,932902,593604,115932,1035625,714728,24866,978541,81433,721792,842201,542471,83288,961584,768112,1044101,358895,457305,418948,754075,949762,861503,454079,894858,216849,737516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]