SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509448 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509448 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424501,209323,967713,481622,821994,223439,434612,147104,92280,962458,775658,320455,771255,1016424,796265,249028,27409,38853,104415,910593,237893,791372,678643,659662,935780,1017048,1022200,258621,58465,68100,419678,1023064,181203,794232,119763,1007830,245225,371616,356759,292010,473212,1025204,1047618,419682,799695,267514,191488,646856,995710,661165,114083,383157,661532,452596,567890,22148,511359,685850,172603,902737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]