SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022177 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022177 [ RunTime:0.003053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812362,65430,93941,1022643,326309,317343,344983,774104,981149,501445,467303,35267,329140,167087,479789,902422,564762,99350,540294,816795,577147,514652,210080,893413,988147,725106,178649,174715,1037835,608098,520097,1030906,890159,649851,741406,361449,536715,211913,992720,555798,749570,985489,803555,906107,728942,661783,165390,879834,251465,157601,768804,597746,709574,895909,764189,694857,83656,208945,75547,62529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002476s ]