SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711004 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711004 [ RunTime:0.002815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166509,606630,380356,546731,611403,971679,187030,632626,55496,981617,943269,357896,498318,458053,562519,123329,773210,507084,578096,1006323,1000089,244192,340272,971630,22197,726474,996326,919499,251817,425519,156862,33236,811082,835671,651203,732049,240300,610136,878057,605846,1029709,625046,729508,875769,348945,17020,207084,683167,263414,728687,15968,522199,523481,896470,99430,507016,466191,891886,56460,618589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]