SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048106 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048106 [ RunTime:0.002834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758238,761403,301441,252807,975260,551403,28537,58530,222383,964726,624220,453170,709102,282506,569200,971706,87741,31382,914986,448567,320366,406116,1008551,952117,753542,168327,326374,1033309,517986,782918,927704,515920,993911,1012816,359072,1017672,264522,649732,714760,938705,412709,381947,455002,658103,504640,671640,559944,275977,436351,181827,278984,596523,256204,498528,935538,595561,965640,64281,220893,110726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001715s ]