SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039535 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039535 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463136,200595,499906,373375,640278,194767,341126,153951,1042369,237790,658875,6412,461453,324747,751198,361524,746862,24170,561928,255703,204261,345676,732170,377631,29431,406980,938470,25782,822955,771364,233415,460954,63352,432611,916926,300202,684647,107495,367020,324492,795660,636787,406769,377550,1031346,510563,169425,523072,19023,924815,759430,577718,757072,65452,769326,864072,627056,848915,448936,523954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001041s ]