SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513335 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513335 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447784,493033,337074,99042,599208,813392,207603,522722,359089,824956,811969,326159,361812,139113,353429,492266,579788,1028086,640208,665354,657324,625682,893487,421690,734430,1003061,929463,751982,1041615,523471,64662,416521,247755,43765,1040976,107136,938729,750097,381135,593690,1037399,348937,165774,451787,399469,1048352,156059,403966,318942,753289,71957,1031664,74258,605780,976580,179491,945068,473476,808061,61395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]