SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40385 LIMIT 1 [ RunTime:0.002186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40385 [ RunTime:0.003917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32925,629150,897340,16482,706070,408028,808610,773142,270107,688059,2513,1042194,528882,661067,1010605,914573,593700,564961,788972,291860,726256,484503,619630,176610,648237,732162,327467,344906,1047562,309987,267004,873154,559698,87569,316476,76676,948834,39889,729132,469928,422817,44224,938161,580940,423060,772030,569161,236964,914936,956537,951444,75017,543506,364444,145052,723893,280777,651862,408597,746715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]