SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102704 LIMIT 1 [ RunTime:0.002945s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102704 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155500,28468,736699,55748,737538,906940,416546,780124,512843,268677,48603,412709,627408,857846,406187,368945,547995,15250,893773,53620,357181,903684,520235,293218,55529,409328,817464,739383,637836,144485,159288,462999,958819,788329,803171,517230,180625,931354,633672,922575,263453,995355,330285,90474,466356,465897,442714,166928,651349,709727,152511,943151,27890,792605,975264,426092,456012,242029,208353,923821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]