SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407239 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407239 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335037,147625,415394,723206,545761,498101,1041876,575229,142412,445667,152101,818275,188131,956207,742479,983021,219160,907508,813991,733444,542465,870627,174378,847387,951513,363504,616688,89115,480321,268109,90297,60553,1026144,763026,862187,915045,8079,354192,147547,486069,801351,683927,25555,490836,922590,910400,158258,867114,539392,439341,760303,589642,525801,759866,273045,898048,737644,981592,197274,986659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]