SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47413 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47413 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863834,691923,481057,356234,514433,305140,205184,1017653,558916,45418,853540,664360,585548,737951,334473,424268,490189,1005378,618928,633384,1000942,915451,763640,88731,677710,80892,416672,925477,716331,239065,187940,181634,416902,165102,121942,163088,381103,13309,1047403,373454,1046041,156007,893543,664222,809121,688533,558149,597827,405439,210747,130439,277873,370349,796285,247138,737045,81323,1029234,22963,693821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]