SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554299 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554299 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451581,334363,403782,912076,1039602,257469,669354,270395,623996,35368,971921,102267,719698,208851,185027,1026019,266326,508919,812362,381331,654094,297439,902027,216830,19334,970858,123595,530972,294455,814140,895738,159661,165263,230433,181693,969811,803745,825687,893015,680089,717094,527223,191382,414613,421343,661003,149736,43310,1037355,353253,535258,1026448,825652,539292,207017,558284,519256,561446,192068,26956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]