SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017316 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017316 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149878,877593,932119,465052,1002371,179015,405722,500381,409948,460184,41518,380467,160976,615206,110940,161,741331,293668,288469,661759,530295,128714,270926,887988,280486,229009,776258,856670,997645,684340,791318,78634,596614,129589,579442,633099,256401,544324,297576,472045,891238,1036730,620924,790802,563055,651374,291997,248746,928687,830631,361141,896058,126539,416603,855718,1014701,70368,958852,602915,981859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]