SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35700 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35700 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793314,560070,445248,261497,541859,334734,705104,83159,909986,1019506,978242,905930,188242,879783,348101,712642,457635,708690,712313,650338,402736,261737,687386,27224,212931,365359,644336,664022,110334,697968,936801,830612,720383,402477,150612,250400,1045095,509015,811785,469991,700245,408164,124586,79083,385787,886975,653648,689831,786266,103503,622700,611336,22070,627781,157099,408206,645265,1022420,947942,240239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]