SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474991 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474991 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492290,648602,177987,253478,471228,666069,600451,837217,709426,450628,896044,451099,140959,323159,928167,488664,738405,444569,1042031,293096,385115,9192,778182,218637,558589,787772,436400,665695,10184,862915,501902,122671,1005937,453268,1008145,625020,32086,544602,303042,878367,453376,154033,165299,820658,698712,744971,120082,1011829,285066,898089,456403,294990,1004113,392425,614931,637340,907406,859440,196508,62276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003249s ]