SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568294 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568294 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725911,410122,190718,108976,784823,206313,309809,394728,986263,628438,658958,201922,855037,365123,748863,688854,13858,774964,792447,358635,244803,483641,381926,1023671,457563,111608,633550,198378,871086,408922,604222,409916,73867,68275,679961,677881,706486,323408,1036314,35625,958861,479555,227755,740975,131746,527451,820013,225807,842032,650070,332545,217650,447082,511185,201107,843787,76790,335551,912170,558845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]