SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54045 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54045 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483062,259340,168705,170595,367765,857007,268380,18832,703550,78057,775451,548792,253720,277873,1034671,208379,969979,258049,909678,590474,1041557,244699,222126,996881,825646,150973,624734,28092,401826,969162,814099,607438,280609,135128,536102,990670,49215,851454,961538,996030,51617,107498,878276,999479,56833,134469,27538,832161,19457,995529,1011176,651763,518285,687825,1012170,1012538,888162,464612,10781,294803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]