SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801740 LIMIT 1 [ RunTime:0.002974s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801740 [ RunTime:0.002557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509784,688897,78794,246690,662764,992936,146559,381717,593665,525007,211291,525005,208188,187014,981309,131251,706147,882970,80016,986536,229389,921362,139143,722874,42696,680258,1043321,982965,552889,157030,618031,926924,354460,456882,836813,44872,768450,447958,589800,294202,587327,127027,258511,380174,270734,138444,15896,985909,345326,911026,41873,41718,858286,478706,655484,722683,785328,428576,680533,333126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]