SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809684 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809684 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016555,543431,191792,226477,1041290,917053,957317,742426,775630,882371,13526,99078,480393,162293,676325,746209,576390,1033730,215790,62755,652827,790461,179112,733000,279476,544182,330714,160718,472008,117510,353760,336303,416737,156980,690929,34710,948431,950069,898418,177519,335147,445946,197855,984255,163605,1038202,195148,904044,380147,961507,890419,569131,162337,550313,750989,862153,655686,475151,932216,498072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]