SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479820 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479820 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447758,699302,718631,453100,291449,284903,501511,239756,133389,794643,503299,288433,571773,551023,356705,255341,58578,920553,222650,172936,313107,792891,256956,237424,351335,902425,355724,430238,671135,20845,680712,867428,782676,339397,869732,640938,345006,838140,1002411,79246,119008,1000585,85668,831080,954679,371489,670160,436864,721639,877836,486723,452658,612905,762349,911261,661496,733968,972267,489319,730501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]